Integrity Constraints in Multiversion Databases

نویسندگان

  • Anne Doucet
  • Stéphane Gançarski
  • Geneviève Jomier
  • Sophie Monties
چکیده

This paper analyses the extension of integrity constraint mechanisms in order to maintain consistency in multiversion databases is studied. Unlike monoversion databases, a multiversion database represents several states of the modeled universe. Thus, both the notion of consistency and the means to maintain it have to be extended. To this aim, we consider new integrity constraints induced by versioning. Constraints are characterized according to several criteria, and a general framework for optimizing their checking in the context of ACID transactions is given. The database versions model CJ90] is used as it ooers a sound basis for the deenition of consistency.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Integrity Constraints and Versions

In this paper, the extension of integrity constraint mechanisms in order to maintain consistency in multiversion databases is studied. Unlike monoversion databases, a multiversion database represents several states of the modeled universe. Thus, both the notion of consistency and the means to maintain it have to be extended. This goal requires studying new integrity constraints induced by versi...

متن کامل

Versions of integrity constraints in multiversiondatabasesAnne

In earlier work, we proposed an integrity constraint mechanism intended to maintain consistency in multiversion databases 6, 5]. However, we did not consider versions of integrity constraints. This paper analyses the extension of this integrity mechanism, in order to express and manage versions of constraints. To make this extension possible, we address two issues. First, we inventory the prope...

متن کامل

Analysis of Real-Time Multi version Concurrency Control Algorithms using Serialisability Graphs

57 ABSTRACT This paper analyses the correctness of Multiversion Concurrency Control(MVCC) algorithms that are commonly deployed in Realtime Databases. Database systems for real-time applications must satisfy timing constraints associated with transactions. Typically, a timing constraint is expressed in the form of a deadline and is represented as a priority to be used by schedulers. MVCC Algori...

متن کامل

Analysis of Impact of Network Delay on Multiversion Conservative Timestamp Algorithms in DDBS

In a distributed environment, users access databases in remote sites via a communication network. The randomness of the network delay may cause operations to arrive at the remote sites out of sequence. Multiversion conservative timestamp algorithms can be used to schedule the operations to maintain the consistency of the databases. We model the algorithms as queueing systems with partial order ...

متن کامل

From Transactional Spatial Databases Integrity Constraints to Spatial Datacubes Integrity Constraints

Spatial multidimensional databases (also called "spatial datacubes") are the cornerstone of the emerging Spatial On-Line Analytical Processing technology (SOLAP). They are aimed at supporting Geographic Knowledge Discovery (GKD) as well as certain types of spatial decision-making. Although these technologies seem promising at first glance, they may provide unreliable results if one does not con...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1996